﻿CREATE TABLE [dbo].[tt_ip_consent]
(
    [id] INT NOT NULL, 
    [sns_id] UNIQUEIDENTIFIER NOT NULL, 
    [client_id] VARCHAR(64) NOT NULL, 
    [open_id] VARCHAR(64) NOT NULL, 
    CONSTRAINT [pk_tt_ip_consent] PRIMARY KEY ([id]), 
    CONSTRAINT [fk_tt_ip_consent_sns] FOREIGN KEY ([sns_id]) REFERENCES [tt_ip_sns]([id]), 
    CONSTRAINT [fk_tt_ip_consent_client] FOREIGN KEY ([client_id]) REFERENCES [tt_ip_client]([id])
)
